package com.woniuxy.dao;

import com.woniuxy.controller.info.ProjectroleInfo;
import com.woniuxy.model.ProjectRole;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author 马世亮
 * @since 2022-02-15
 */
public interface ProjectRoleDao extends BaseMapper<ProjectRole> {

    @Select("SELECT * FROM project_role WHERE project_role_delect = 0 ORDER BY project_role_num ")
    List<ProjectRole> getRolesByPid();

    @Select("SELECT project_role_id,project_role_name FROM project_role WHERE project_role_delect = 0 AND system_sign='产品经理'")
    List<ProjectroleInfo> selectManagerRole();
}
